OpenEdge Data Management:<br />DataServer for ORACLE Progress-to-ORACLE utility

Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Progress-to-ORACLE utility

The OpenEdge DataServer for ORACLE supports the Progress-to-ORACLE utility that allows you to migrate an OpenEdge database to an ORACLE database. While the DataServer typically makes an ORACLE database conform to an OpenEdge database, this utility provides compatibility in the opposite direction. It copies an existing OpenEdge database schema into a target ORACLE database. The utility performs the following tasks:

Creates objects in the target ORACLE database.

Creates the schema holder and schema image.

Optionally populates the ORACLE database by dumping and loading the data from the OpenEdge database.

The ORACLE database you create with this utility is a basis for an application database. Before deploying your new ORACLE database, you might want to make manual adjustments to take advantage of additional ORACLE features that are not supported by the migration utility, such as clustering and multiple tablespaces.

The Progress-to-ORACLE utility has the following requirements:

A local OpenEdge database.

ORACLE permissions, as Table 7–3 describes.

Table 7–3: Permissions for the Progress-to-ORACLE utility

Permission

Object

CREATE SESSION

Database

CREATE TABLE

Database

CREATE SEQUENCE

Database

Permission

Object

SELECT

System objects:

sys.argument$ sys.col$ sys.com$ sys.con$ sys.dual sys.icol$ sys.ind$ sys.link$ sys.obj$ sys.procedure$ sys.seq$ sys.syn$ sys.tab$ sys.ts$ sys.user$ sys.view$

Enough quota

Default table space

Permission	Object
`CREATE SESSION`	Database
`CREATE TABLE`	Database
`CREATE SEQUENCE`	Database
Permission	Object
`SELECT`	System objects: `sys.argument$ sys.col$ sys.com$ sys.con$ sys.dual sys.icol$ sys.ind$ sys.link$ sys.obj$ sys.procedure$ sys.seq$ sys.syn$ sys.tab$ sys.ts$ sys.user$ sys.view$`
Enough quota	Default table space